<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Preparing for Backup">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="en-us_topic_0000002200155001.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="">
<meta name="DC.Publisher" content="20250306">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="EN-US_TOPIC_0000002164828450">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Preparing for Backup</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="EN-US_TOPIC_0000002164828450"></a><a name="EN-US_TOPIC_0000002164828450"></a>

<h1 class="topictitle1">Preparing for Backup</h1>
<div><ul><li>Before backing up an SAP HANA database, ensure that the host where the client is installed has sufficient hardware resources (such as memory, CPU, and storage resources). You are advised to use the Quick Sizer tool provided by the system after the SAP HANA database is installed to evaluate the hardware requirements for running a host. The Quick Sizer tool generates the recommended configurations for key resources such as memory, CPUs, and storage upon analysis of the entered service scenario data. You can visit <a href="https://www.sap.com/about/benchmark/sizing.quick-sizer.html#quick-sizer" target="_blank" rel="noopener noreferrer">Quick Sizer</a> to get related guidance.</li><li>Before backing up an SAP HANA database, prepare related configuration information by following instructions in <a href="#EN-US_TOPIC_0000002164828450__en-us_topic_0000001455091930_table10744125193920">Table 1</a>.
<div class="tablenoborder"><a name="EN-US_TOPIC_0000002164828450__en-us_topic_0000001455091930_table10744125193920"></a><a name="en-us_topic_0000001455091930_table10744125193920"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002164828450__en-us_topic_0000001455091930_table10744125193920" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Preparations for backup</caption><colgroup><col style="width:17.34%"><col style="width:14.49%"><col style="width:51.83%"><col style="width:16.34%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="17.34%" id="mcps1.3.1.2.2.2.5.1.1"><p>Item</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="14.49%" id="mcps1.3.1.2.2.2.5.1.2"><p>Mandatory or Not (Y/N)</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="51.83%" id="mcps1.3.1.2.2.2.5.1.3"><p>How to Obtain</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="16.34%" id="mcps1.3.1.2.2.2.5.1.4"><p>To Be Used In</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="17.34%" headers="mcps1.3.1.2.2.2.5.1.1 "><p>Database name and instance ID</p>
</td>
<td class="cellrowborder" valign="top" width="14.49%" headers="mcps1.3.1.2.2.2.5.1.2 "><p>Y</p>
</td>
<td class="cellrowborder" valign="top" width="51.83%" headers="mcps1.3.1.2.2.2.5.1.3 "><div class="p">Name of the database to be protected. You can query the database name using the following method:<ol><li>Use PuTTY to log in to the host where the SAP HANA database resides.</li><li>Run the following command to switch to the SAP system user <em>&lt;sid&gt;</em><strong>adm</strong> to log in to the SAP HANA database terminal system. The username <strong>s00adm</strong> is used as an example.<div class="note"><span class="notetitle"> NOTE: </span><div class="notebody"><p><em>&lt;sid&gt;</em><strong>adm</strong> is an SAP system user. <em>&lt;sid&gt;</em> indicates the SAP HANA system ID, consisting of three alphanumeric characters defined during the SAP HANA system installation and uniquely identifies an SAP HANA system. <strong>adm</strong> is short for administrator, indicating that the user is used for system management.</p>
</div></div>
<pre class="screen">su - <em>s00adm</em>
hdbsql -i 00 -n localhost:30013 -d SYSTEMDB -u SYSTEM -p <em>Password customized by the user during database installation</em>;</pre>
</li><li>Run the following command to query the database name and instance ID:<pre class="screen">SELECT * FROM M_DATABASES;</pre>
<p>Information similar to the following is displayed, where <strong>SYSTEMDB</strong> is the database name and <strong>S00</strong> is the instance ID.</p>
<pre class="screen">DATABASE_NAME,DESCRIPTION,ACTIVE_STATUS,ACTIVE_STATUS_DETAILS,OS_USER,OS_GROUP,RESTART_MODE
"SYSTEMDB","SystemDB-S00-00","YES","","","","DEFAULT"
"S00","S00-00","YES","","","","DEFAULT"</pre>
</li></ol>
</div>
</td>
<td class="cellrowborder" rowspan="5" valign="top" width="16.34%" headers="mcps1.3.1.2.2.2.5.1.4 "><p><a href="en-us_topic_0000002200155025.html">Step 1: Registering the SAP HANA Database (File Backup Mode)</a></p>
<p><a href="en-us_topic_0000002200155077.html">Step 1: Registering the SAP HANA Database (Backint Backup Mode)</a></p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.1 "><p>Database host</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.2 "><p>Y</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.3 "><p>Host where the database resides.</p>
<p>If the database is deployed in a cluster, select all hosts where the database is distributed.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.1 "><p>Name and password of a database user</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.2 "><p>Y</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.3 "><p>Username and password used for accessing the database.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.1 "><p><strong>systemId</strong> and <strong>SQL Port</strong> of the database</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.2 "><p>Y</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.3 "><ul><li>You can query <strong>systemId</strong> on the SAP HANA Studio, as shown in the following figure.<p><span><img src="en-us_image_0000002164828502.png"></span></p>
</li><li>SQL Port indicates the SQL port on the master node of the system database. You can query the SQL port on the SAP HANA Studio.<p>In single-tenant mode, the default SQL Port is <strong>30015</strong>. In multi-tenant mode, the default SQL Port is <strong>30013</strong>.</p>
</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.1 "><p>Username and password of the system database</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.2 "><p>N</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.5.1.3 "><p>This parameter is required only when the database to be protected is a tenant database.</p>
</td>
</tr>
</tbody>
</table>
</div>
</li></ul>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="en-us_topic_0000002200155001.html">Backup</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>